package com.version1.diabeco.data;

import android.provider.BaseColumns;

public class DiabecoContract {

	// @formatter:off
	public  static final int DATABASE_VERSION = 2;
	public  static final String DATABASE_NAME = "Diabeco2.db";
	private static final String PRIMARY_KEY = " PRIMARY KEY";
	private static final String AUTOINCREMENT = " AUTOINCREMENT";
	private static final String COMMA_SEP = ",";

	// Data types
	private static final String TYPE_TEXT = " TEXT";
	private static final String TYPE_REAL = " REAL";
	private static final String TYPE_INTEGER = " INTEGER";
	private static final String TYPE_DATE = " INTEGER";
	private static final String TYPE_TIME = " INTEGER";
	private static final String TYPE_BOOLE = " INTEGER"; //1 (true) 0 (false)
	
	// Constraints
	private static final String CONSTRAINT_SINGLE_COLUMN_UNIQUE = " UNIQUE ";
	

	private DiabecoContract() {
	}
		//Perfil de Usuario
		public static abstract class PerfilUsuario implements BaseColumns {
			public static final String TABLE_NAME = "PerfilUsuario";
			public static final String COLUMNA_ID = "_id";	//Es el alias!!!		
			public static final String COLUMNA_NOMBRE = "nombre";
			public static final String COLUMNA_APELLIDO = "apellido";
			public static final String COLUMNA_EMAIL = "email";
			public static final String COLUMNA_SEXO = "sexo";
			public static final String COLUMNA_FECHA_NACIMIENTO = "fechaNacimiento";
			public static final String COLUMNA_TIPO_DIABETES = "tipoDiabetes";
			public static final String COLUMNA_UMBRAL_BAJO = "umbralBajo";
			public static final String COLUMNA_UMBRAL_ALTO = "umbralAlto";
			public static final String COLUMNA_UM_GLUCOSA = "umGlucosa";
			public static final String COLUMNA_PESO = "peso";
			public static final String COLUMNA_UM_PESO = "umPeso";
			public static final String COLUMNA_ALTURA = "altura";
			public static final String COLUMNA_UM_ALTURA = "umAltura";
			public static final String COLUMNA_ACTIVO = "activo";
		}

		public static final String SQL_CREATE_TABLE_PERFIL_USUARIO = 
				"CREATE TABLE "
				+ DiabecoContract.PerfilUsuario.TABLE_NAME
				+ " (" 
				+ DiabecoContract.PerfilUsuario._ID + TYPE_TEXT + PRIMARY_KEY + COMMA_SEP //Es el alias!!!
				+ DiabecoContract.PerfilUsuario.COLUMNA_NOMBRE + TYPE_TEXT + COMMA_SEP
				+ DiabecoContract.PerfilUsuario.COLUMNA_APELLIDO + TYPE_TEXT + COMMA_SEP
				+ DiabecoContract.PerfilUsuario.COLUMNA_EMAIL + TYPE_TEXT + COMMA_SEP				
				+ DiabecoContract.PerfilUsuario.COLUMNA_SEXO + TYPE_TEXT + COMMA_SEP
				+ DiabecoContract.PerfilUsuario.COLUMNA_FECHA_NACIMIENTO + TYPE_DATE + COMMA_SEP
				+ DiabecoContract.PerfilUsuario.COLUMNA_TIPO_DIABETES + TYPE_INTEGER + COMMA_SEP
				+ DiabecoContract.PerfilUsuario.COLUMNA_UMBRAL_BAJO + TYPE_INTEGER + COMMA_SEP
				+ DiabecoContract.PerfilUsuario.COLUMNA_UMBRAL_ALTO + TYPE_INTEGER + COMMA_SEP
				+ DiabecoContract.PerfilUsuario.COLUMNA_UM_GLUCOSA + TYPE_TEXT + COMMA_SEP
				+ DiabecoContract.PerfilUsuario.COLUMNA_PESO + TYPE_REAL + COMMA_SEP
				+ DiabecoContract.PerfilUsuario.COLUMNA_UM_PESO + TYPE_TEXT + COMMA_SEP
				+ DiabecoContract.PerfilUsuario.COLUMNA_ALTURA + TYPE_REAL + COMMA_SEP
				+ DiabecoContract.PerfilUsuario.COLUMNA_UM_ALTURA + TYPE_TEXT + COMMA_SEP 
				+ DiabecoContract.PerfilUsuario.COLUMNA_ACTIVO + TYPE_BOOLE + ")";

		public static final String SQL_DELETE_TABLE_PERFIL_USUARIO = 
				"DROP TABLE IF EXISTS " + DiabecoContract.PerfilUsuario.TABLE_NAME;

		public static final String SQL_TRUNCATE_TABLE_PERFIL_USUARIO = 
				"DELETE FROM " + DiabecoContract.PerfilUsuario.TABLE_NAME;
		
	//Registro Glucosa
	public static abstract class RegistroGlucosa implements BaseColumns {
		public static final String TABLE_NAME = "RegistroGlucosa";
		public static final String COLUMNA_ID = "_id";		
		public static final String COLUMNA_ALIAS = "alias";
		public static final String COLUMNA_FECHA = "fecha";
		public static final String COLUMNA_CANTIDAD = "cantidad";
		public static final String COLUMNA_UM_GLUCOSA = "um_glucosa";
		public static final String COLUMNA_NIVEL_RIESGO = "nivel_riesgo";
		public static final String COLUMNA_ICON_RESOURCE_ID = "iconResourceId";
		public static final String COLUMNA_MOMENTO = "momento";
		public static final String COLUMNA_CUANDO = "cuando";
		public static final String COLUMNA_MUJER = "mujer";
		public static final String COLUMNA_OBSERVACIONES = "observaciones";
		public static final String COLUMNA_NOTA = "nota";
	}

	public static final String SQL_CREATE_TABLE_REGISTRO_GLUCOSA = 
			"CREATE TABLE "
			+ DiabecoContract.RegistroGlucosa.TABLE_NAME
			+ " (" 
			+ DiabecoContract.RegistroGlucosa._ID + TYPE_INTEGER + PRIMARY_KEY + AUTOINCREMENT + COMMA_SEP
			+ DiabecoContract.RegistroGlucosa.COLUMNA_ALIAS + TYPE_TEXT + COMMA_SEP
			+ DiabecoContract.RegistroGlucosa.COLUMNA_FECHA + TYPE_DATE + COMMA_SEP
			+ DiabecoContract.RegistroGlucosa.COLUMNA_CANTIDAD + TYPE_INTEGER + COMMA_SEP
			+ DiabecoContract.RegistroGlucosa.COLUMNA_UM_GLUCOSA + TYPE_TEXT + COMMA_SEP
			+ DiabecoContract.RegistroGlucosa.COLUMNA_NIVEL_RIESGO + TYPE_TEXT + COMMA_SEP
			+ DiabecoContract.RegistroGlucosa.COLUMNA_ICON_RESOURCE_ID + TYPE_INTEGER + COMMA_SEP
			+ DiabecoContract.RegistroGlucosa.COLUMNA_MOMENTO + TYPE_TEXT + COMMA_SEP
			+ DiabecoContract.RegistroGlucosa.COLUMNA_CUANDO + TYPE_TEXT + COMMA_SEP
			+ DiabecoContract.RegistroGlucosa.COLUMNA_MUJER + TYPE_TEXT + COMMA_SEP
			+ DiabecoContract.RegistroGlucosa.COLUMNA_OBSERVACIONES + TYPE_TEXT + COMMA_SEP
			+ DiabecoContract.RegistroGlucosa.COLUMNA_NOTA + TYPE_TEXT + ")";

	public static final String SQL_DELETE_TABLE_REGISTRO_GLUCOSA = 
			"DROP TABLE IF EXISTS " + DiabecoContract.RegistroGlucosa.TABLE_NAME;

	public static final String SQL_TRUNCATE_TABLE_REGISTRO_GLUCOSA = 
			"DELETE FROM " + DiabecoContract.RegistroGlucosa.TABLE_NAME;

	// Registro Alimento
	public static abstract class Alimento implements BaseColumns {
		public static final String TABLE_NAME = "Alimento";
		public static final String COLUMNA_ID = "_id";		
		public static final String COLUMNA_NOMBRE = "nombre";
		public static final String COLUMNA_HDECARBONO = "hdecarbono";
	}

	public static final String SQL_CREATE_TABLE_REGISTRO_ALIMENTO = 
			"CREATE TABLE "
			+ DiabecoContract.Alimento.TABLE_NAME
			+ " (" 
			+ DiabecoContract.Alimento._ID + TYPE_INTEGER + PRIMARY_KEY + AUTOINCREMENT + COMMA_SEP
			+ DiabecoContract.Alimento.COLUMNA_NOMBRE + TYPE_TEXT + COMMA_SEP
			+ DiabecoContract.Alimento.COLUMNA_HDECARBONO + TYPE_TEXT
			 + ")";

	public static final String SQL_DELETE_TABLE_REGISTRO_ALIMENTO = 
			"DROP TABLE IF EXISTS " + DiabecoContract.Alimento.TABLE_NAME;
	
	public static final String SQL_TRUNCATE_TABLE_REGISTRO_ALIMENTO = 
			"DELETE FROM " + DiabecoContract.Alimento.TABLE_NAME;
	
	// Registro Comida
	public static abstract class RegistroComida implements BaseColumns {
		public static final String TABLE_NAME = "RegistroComida";
		public static final String COLUMNA_ID = "_id";		
		public static final String COLUMNA_ALIAS = "alias";
		public static final String COLUMNA_FECHA = "fecha";
		public static final String COLUMNA_CUANDO = "cuando";
	}

	public static final String SQL_CREATE_TABLE_REGISTRO_COMIDA = 
			"CREATE TABLE "
			+ DiabecoContract.RegistroComida.TABLE_NAME
			+ " (" 
			+ DiabecoContract.RegistroComida._ID + TYPE_INTEGER + PRIMARY_KEY + AUTOINCREMENT + COMMA_SEP
			+ DiabecoContract.RegistroComida.COLUMNA_ALIAS + TYPE_TEXT + COMMA_SEP
			+ DiabecoContract.RegistroComida.COLUMNA_FECHA + TYPE_DATE + COMMA_SEP
			+ DiabecoContract.RegistroComida.COLUMNA_CUANDO + TYPE_TEXT + ")";

	public static final String SQL_DELETE_TABLE_REGISTRO_COMIDA = 
			"DROP TABLE IF EXISTS " + DiabecoContract.RegistroComida.TABLE_NAME;
	
	public static final String SQL_TRUNCATE_TABLE_REGISTRO_COMIDA = 
			"DELETE FROM " + DiabecoContract.RegistroComida.TABLE_NAME;

	// Registro Detalle Comida
	public static abstract class RegistroDetalleComida implements BaseColumns {
		public static final String TABLE_NAME = "RegistroDetalleComida";
		public static final String COLUMNA_ALIAS = "alias";
		public static final String COLUMNA_HDECARBONO_AJUSTADO = "hdecarbono_ajustado";
		public static final String COLUMNA_ID_COMIDA = "id_comida";		
		public static final String COLUMNA_ID_ALIMENTO = "id_alimento";
	}

	public static final String SQL_CREATE_TABLE_REGISTRO_DETALLE_COMIDA = 
			"CREATE TABLE "
			+ DiabecoContract.RegistroDetalleComida.TABLE_NAME
			+ " (" 
			+ DiabecoContract.RegistroDetalleComida._ID + TYPE_INTEGER + PRIMARY_KEY + AUTOINCREMENT + COMMA_SEP
			+ DiabecoContract.RegistroDetalleComida.COLUMNA_ALIAS + TYPE_TEXT + COMMA_SEP
			+ DiabecoContract.RegistroDetalleComida.COLUMNA_HDECARBONO_AJUSTADO + TYPE_TEXT + COMMA_SEP
			+ DiabecoContract.RegistroDetalleComida.COLUMNA_ID_COMIDA + TYPE_TEXT + COMMA_SEP
			+ DiabecoContract.RegistroDetalleComida.COLUMNA_ID_ALIMENTO + TYPE_TEXT + COMMA_SEP
			+ "FOREIGN KEY(" + DiabecoContract.RegistroDetalleComida.COLUMNA_ID_COMIDA + ") REFERENCES " + DiabecoContract.RegistroComida.TABLE_NAME + "(_ID) ON DELETE CASCADE " + COMMA_SEP
			+ "FOREIGN KEY(" + DiabecoContract.RegistroDetalleComida.COLUMNA_ID_ALIMENTO + ") REFERENCES " + DiabecoContract.Alimento.TABLE_NAME + "(_ID)"
			+ ")";

	public static final String SQL_DELETE_TABLE_REGISTRO_DETALLE_COMIDA = 
			"DROP TABLE IF EXISTS " + DiabecoContract.RegistroDetalleComida.TABLE_NAME;
	
	public static final String SQL_TRUNCATE_TABLE_REGISTRO_DETALLE_COMIDA = 
			"DELETE FROM " + DiabecoContract.RegistroDetalleComida.TABLE_NAME;

	//Registro Medicacion 
	public static abstract class RegistroMedicacion implements BaseColumns {
		public static final String TABLE_NAME = "RegistroMedicacion";
		public static final String COLUMNA_ID = "_id";		
		public static final String COLUMNA_ALIAS = "alias";
		public static final String COLUMNA_FECHA = "fecha";
		public static final String COLUMNA_ID_MEDICAMENTO = "id_medicamento";
		public static final String COLUMNA_LUGAR_APLICACION = "lugar_aplicacion";
		public static final String COLUMNA_DOSIS = "dosis";
		public static final String COLUMNA_UM_DOSIS = "um_dosis";
	}

	public static final String SQL_CREATE_TABLE_REGISTRO_MEDICACION = 
			"CREATE TABLE "
			+ DiabecoContract.RegistroMedicacion.TABLE_NAME
			+ " (" 
			+ DiabecoContract.RegistroMedicacion._ID + TYPE_INTEGER + PRIMARY_KEY +AUTOINCREMENT + COMMA_SEP
			+ DiabecoContract.RegistroMedicacion.COLUMNA_ALIAS + TYPE_TEXT + COMMA_SEP
			+ DiabecoContract.RegistroMedicacion.COLUMNA_FECHA + TYPE_DATE + COMMA_SEP
			+ DiabecoContract.RegistroMedicacion.COLUMNA_ID_MEDICAMENTO + TYPE_INTEGER + COMMA_SEP
			+ DiabecoContract.RegistroMedicacion.COLUMNA_LUGAR_APLICACION + TYPE_TEXT + COMMA_SEP
			+ DiabecoContract.RegistroMedicacion.COLUMNA_DOSIS + TYPE_TEXT + COMMA_SEP
			+ DiabecoContract.RegistroMedicacion.COLUMNA_UM_DOSIS + TYPE_TEXT + COMMA_SEP
			+ "FOREIGN KEY(" + DiabecoContract.RegistroMedicacion.COLUMNA_ID_MEDICAMENTO + ") REFERENCES " + DiabecoContract.Medicamento.TABLE_NAME + "(_ID)"
			+ ")";	

	public static final String SQL_DELETE_TABLE_REGISTRO_MEDICACION = 
			"DROP TABLE IF EXISTS " + DiabecoContract.RegistroMedicacion.TABLE_NAME;
	
	public static final String SQL_TRUNCATE_TABLE_REGISTRO_MEDICACION = 
			"DELETE FROM " + DiabecoContract.RegistroMedicacion.TABLE_NAME;
	
	//Registro Actividad Fisica
	public static abstract class RegistroActividadFisica implements BaseColumns {
		public static final String TABLE_NAME = "RegistroActividadFisica";
		public static final String COLUMNA_ID = "_id";		
		public static final String COLUMNA_ALIAS = "alias";
		public static final String COLUMNA_FECHA = "fecha";
		public static final String COLUMNA_DESC_EJERCICIO = "desc_ejercicio";
		public static final String COLUMNA_DURACION = "duracion";
		public static final String COLUMNA_INTENSIDAD = "intesidad";
	}
	
	public static final String SQL_CREATE_TABLE_REGISTRO_ACTIVIDAD_FISICA = 
			"CREATE TABLE "
			+ DiabecoContract.RegistroActividadFisica.TABLE_NAME
			+ " (" 
			+ DiabecoContract.RegistroActividadFisica._ID + TYPE_INTEGER + PRIMARY_KEY +AUTOINCREMENT + COMMA_SEP
			+ DiabecoContract.RegistroActividadFisica.COLUMNA_ALIAS + TYPE_TEXT + COMMA_SEP
			+ DiabecoContract.RegistroActividadFisica.COLUMNA_FECHA + TYPE_DATE + COMMA_SEP
			+ DiabecoContract.RegistroActividadFisica.COLUMNA_DESC_EJERCICIO + TYPE_INTEGER + COMMA_SEP
			+ DiabecoContract.RegistroActividadFisica.COLUMNA_DURACION + TYPE_TEXT + COMMA_SEP
			+ DiabecoContract.RegistroActividadFisica.COLUMNA_INTENSIDAD + TYPE_TEXT + ")";	

	public static final String SQL_DELETE_TABLE_REGISTRO_ACTIVIDAD_FISICA = 
			"DROP TABLE IF EXISTS " + DiabecoContract.RegistroActividadFisica.TABLE_NAME;	
	
	public static final String SQL_TRUNCATE_TABLE_REGISTRO_ACTIVIDAD_FISICA = 
			"DELETE FROM " + DiabecoContract.RegistroActividadFisica.TABLE_NAME;	
	
	//Registro Peso 
	public static abstract class RegistroPeso implements BaseColumns {
		public static final String TABLE_NAME = "RegistroPeso";
		public static final String COLUMNA_ID = "_id";		
		public static final String COLUMNA_ALIAS = "alias";
		public static final String COLUMNA_FECHA = "fecha";
		public static final String COLUMNA_PESO = "peso";				
		public static final String COLUMNA_UM_PESO = "um_peso";
		public static final String COLUMNA_IMC = "imc";
		public static final String COLUMNA_IMC_TIPO = "imc_tipo";
	}
	
	public static final String SQL_CREATE_TABLE_REGISTRO_PESO = 
			"CREATE TABLE "
			+ DiabecoContract.RegistroPeso.TABLE_NAME
			+ " (" 
			+ DiabecoContract.RegistroPeso._ID + TYPE_INTEGER + PRIMARY_KEY + AUTOINCREMENT + COMMA_SEP
			+ DiabecoContract.RegistroPeso.COLUMNA_ALIAS + TYPE_TEXT + COMMA_SEP
			+ DiabecoContract.RegistroPeso.COLUMNA_FECHA + TYPE_DATE + COMMA_SEP
			+ DiabecoContract.RegistroPeso.COLUMNA_PESO + TYPE_REAL + COMMA_SEP
			+ DiabecoContract.RegistroPeso.COLUMNA_UM_PESO + TYPE_TEXT + COMMA_SEP
			+ DiabecoContract.RegistroPeso.COLUMNA_IMC + TYPE_REAL + COMMA_SEP
			+ DiabecoContract.RegistroPeso.COLUMNA_IMC_TIPO + TYPE_TEXT + ")";

	public static final String SQL_DELETE_TABLE_REGISTRO_PESO = 
			"DROP TABLE IF EXISTS " + DiabecoContract.RegistroPeso.TABLE_NAME;		
	
	public static final String SQL_TRUNCATE_TABLE_REGISTRO_PESO = 
			"DELETE FROM " + DiabecoContract.RegistroPeso.TABLE_NAME;		

	//Medicamento
	public static abstract class Medicamento implements BaseColumns {
		public static final String TABLE_NAME = "Medicamento";
		public static final String COLUMNA_ID = "_id";
		public static final String COLUMNA_ALIAS = "alias";
		public static final String COLUMNA_TIPO = "tipo";
		public static final String COLUMNA_DESCRIPCION = "descripcion";				
		public static final String COLUMNA_ICON_RESOURCE_ID = "iconResourceId";				
	}	
	
	public static final String SQL_CREATE_TABLE_MEDICAMENTO = 
			"CREATE TABLE "
			+ DiabecoContract.Medicamento.TABLE_NAME
			+ " (" 
			+ DiabecoContract.Medicamento._ID + TYPE_INTEGER + PRIMARY_KEY + AUTOINCREMENT + COMMA_SEP
			+ DiabecoContract.Medicamento.COLUMNA_ALIAS + TYPE_TEXT + COMMA_SEP
			+ DiabecoContract.Medicamento.COLUMNA_TIPO + TYPE_DATE + COMMA_SEP
			+ DiabecoContract.Medicamento.COLUMNA_DESCRIPCION + TYPE_TIME + CONSTRAINT_SINGLE_COLUMN_UNIQUE + COMMA_SEP
			+ DiabecoContract.Medicamento.COLUMNA_ICON_RESOURCE_ID + TYPE_INTEGER
			+ ")";	

	public static final String SQL_DELETE_TABLE_MEDICAMENTO = 
			"DROP TABLE IF EXISTS " + DiabecoContract.Medicamento.TABLE_NAME;		

	public static final String SQL_TRUNCATE_TABLE_MEDICAMENTO = 
			"DELETE FROM " + DiabecoContract.Medicamento.TABLE_NAME;
	
	//Geocercas
	public static abstract class Geocerca implements BaseColumns {
		public static final String TABLE_NAME = "Geocerca";
		public static final String COLUMNA_ID = "_id";		
		public static final String COLUMNA_ALIAS = "alias";
		public static final String COLUMNA_NOMBRE = "nombre";
		public static final String COLUMNA_TIPO_REGISTRO = "tipo_registro";
		public static final String COLUMNA_ACTIVADA = "activada";
		public static final String COLUMNA_ULTIMO_INGRESO = "ultimo_ingreso";
		public static final String COLUMNA_ULTIMO_EGRESO = "ultima_salida";
	}

	public static final String SQL_CREATE_TABLE_GEOCERCA = 
			"CREATE TABLE "
			+ DiabecoContract.Geocerca.TABLE_NAME
			+ " (" 
			+ DiabecoContract.Geocerca._ID + TYPE_INTEGER + PRIMARY_KEY + AUTOINCREMENT + COMMA_SEP
			+ DiabecoContract.Geocerca.COLUMNA_ALIAS + TYPE_TEXT + COMMA_SEP
			+ DiabecoContract.Geocerca.COLUMNA_NOMBRE + TYPE_TEXT + COMMA_SEP
			+ DiabecoContract.Geocerca.COLUMNA_ACTIVADA + TYPE_BOOLE + COMMA_SEP
			+ DiabecoContract.Geocerca.COLUMNA_ULTIMO_INGRESO + TYPE_INTEGER + COMMA_SEP
			+ DiabecoContract.Geocerca.COLUMNA_ULTIMO_EGRESO + TYPE_INTEGER + COMMA_SEP
			+ DiabecoContract.Geocerca.COLUMNA_TIPO_REGISTRO + TYPE_BOOLE + ")";

	public static final String SQL_DELETE_TABLE_GEOCERCA = 
			"DROP TABLE IF EXISTS " + DiabecoContract.Geocerca.TABLE_NAME;

	public static final String SQL_TRUNCATE_TABLE_GEOCERCA = 
			"DELETE FROM " + DiabecoContract.Geocerca.TABLE_NAME;

	//Vertices Geocercas
	public static abstract class VerticeGeocerca implements BaseColumns {
		public static final String TABLE_NAME = "VerticeGeocerca";
		public static final String COLUMNA_ID = "_id";		
		public static final String COLUMNA_ID_GEOCERCA = "id_geocerca";
		public static final String COLUMNA_ORDEN = "orden";
		public static final String COLUMNA_LATITUD = "latitud";
		public static final String COLUMNA_LONGITUD = "longitud";
	}

	public static final String SQL_CREATE_TABLE_VERTICE_GEOCERCA = 
			"CREATE TABLE "
			+ DiabecoContract.VerticeGeocerca.TABLE_NAME
			+ " (" 
			+ DiabecoContract.VerticeGeocerca._ID + TYPE_INTEGER + PRIMARY_KEY + AUTOINCREMENT + COMMA_SEP
			+ DiabecoContract.VerticeGeocerca.COLUMNA_ID_GEOCERCA + TYPE_INTEGER + COMMA_SEP
			+ DiabecoContract.VerticeGeocerca.COLUMNA_ORDEN + TYPE_INTEGER + COMMA_SEP
			+ DiabecoContract.VerticeGeocerca.COLUMNA_LATITUD + TYPE_REAL + COMMA_SEP
			+ DiabecoContract.VerticeGeocerca.COLUMNA_LONGITUD + TYPE_REAL + COMMA_SEP
			+ "FOREIGN KEY(" + DiabecoContract.VerticeGeocerca.COLUMNA_ID_GEOCERCA + ") REFERENCES " + DiabecoContract.Geocerca.TABLE_NAME + "(_ID) ON DELETE CASCADE "
			+ ")";

	public static final String SQL_DELETE_TABLE_VERTICE_GEOCERCA = 
			"DROP TABLE IF EXISTS " + DiabecoContract.VerticeGeocerca.TABLE_NAME;

	public static final String SQL_TRUNCATE_TABLE_VERTICE_GEOCERCA = 
			"DELETE FROM " + DiabecoContract.VerticeGeocerca.TABLE_NAME;

	// @formatter:on

}
